SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[_PatientActivation_Activation]
    @PatientCode NCHAR(11) ,
    @StatusId NVARCHAR(20) ,
    @UpdateUser NVARCHAR(200) ,
    @Result INT OUT ,
    @Id NVARCHAR(20) OUT ,
    @Note NVARCHAR(500) OUT
AS 
    BEGIN
        EXEC AppointmentSystem.dbo.[_Appointment_UpdateStatus] @PatientCode = @PatientCode, -- nchar(11)
            @StatusId = @StatusId, -- nvarchar(20)
            @UpdateUser = @UpdateUser, -- nvarchar(200)
            @Result = @Result OUTPUT, -- int
            @Id = @Id OUTPUT, -- nvarchar(20)
            @Note = @Note OUTPUT -- nvarchar(500)
    END
	
GO
